﻿CREATE TABLE [dbo].[UOM] (
    [Id]                 UNIQUEIDENTIFIER DEFAULT (newid()) NOT NULL,
    [Name]               NVARCHAR (32)    NOT NULL,
    [Symbol]             NVARCHAR (16)    NOT NULL,
    [Type]               INT              DEFAULT ((1)) NOT NULL,
    [Rate]               FLOAT (53)       DEFAULT ((1.0)) NULL,
    [IsLock]             BIT              DEFAULT ((0)) NULL,
    [LastModifiedTime]   DATETIME         NULL,
    [LastModifiedUserID] UNIQUEIDENTIFIER NULL,
    PRIMARY KEY CLUSTERED ([Id] ASC),
    CONSTRAINT [FK4A1470F11E65B0E] FOREIGN KEY ([LastModifiedUserID]) REFERENCES [dbo].[UserProfile] ([ID]),
    UNIQUE NONCLUSTERED ([Name] ASC),
    UNIQUE NONCLUSTERED ([Symbol] ASC)
);

